About the class: This is a combined certificate training of Microsoft Excel and Microsoft Powerpoint. This training encompasses all the training from "Microsoft Excel Training With Certificate" and "Microsoft Powerpoint Training with Certificate". This is an online video training class. The best way to benefit from this class is to view all the lectures in full screen and sit through all the lectures at least once. All lectures are video lectures. What is Microsoft Powerpoint? Microsoft Powerpoint is a software that is used for making presentations. This class teaches how to make a Microsoft Powerpoint Presentation. Microsoft Powerpoint is the most commonly used software for the creation of presentations. Knowing how to make a presentation is very valuable in the communication of ideas. Corporations around the World rely on Microsoft Powerpoint for communicating their ideas and messages to mass audiences. At the core of every international meeting lies a Powerpoint Presentation. This class teaches you how to think in Powerpoint. The ability to communicate your ideas to the World is your greatest asset. We are here to show the tools you have access to for achieving this goal. Why learn Microsoft Powerpoint? There will be many circumstances throughout your career and personal life when you will have to educate an audience or communicate a message in a formalized manner. Powerpoint is the tool that will allow you to achieve this goal. Powerpoint can be used for communicating ideas of all levels of complexity. It is very commonly utilized by University Professors, Executives and heads of states to make presentations. Whatever your goal may be, knowing Powerpoint will help you achieve your goal. Who is this class for? This is a beginner and intermediate level class. Topics covered in class? Interface components of Powerpoint are covered. Sample presentations are made to show the functionality of Powerpoint. The features of Powerpoint are implemented on these sample presentations. Most commonly used features of Power Point are highlighted and visited several times throughout the class. ~~~~~~~~~~ What is Microsoft Excel? Microsoft excel is a software that allows its users the ability to find a simple solution to daily data related problems. Excel can be utilized to access most problems in a mathematical spreadsheet format. For example: Let's say you want to manage your finances. Excel offers a solution by which a user can make a list of expenses and maintain an ongoing log of incurred expenses. Excel offers a drawing board for daily challenges in a spreadsheet format. Excel allows its users the ability to enter data in a table format. After arranging the data in an excel sheet users are then able to perform calculations on this data for the purpose of data analysis. The type of calculations that needed to be made over hundreds of pages of paper can now be made in a single spreadsheet through Microsoft Excel. Why learn Microsoft Excel? There is a very valid and compelling business reason for learning Excel. However more compelling than the business reason is the value excel brings into our personal lives. Excel can serve as a decision making tool as well as a personal life management tool. Management of personal finances becomes significantly easier with the help of Microsoft Excel. Other very common uses of Excel in person life include job application management, weight management, vacation budget management, market analysis and decision analysis. On the business end, excel is essential for all business success. Microsoft Excel lies at the core of all business decision making. The charting feature of excel allows for the representation of data in a colorful format that plays an integral role in business communication. Microsoft Excel is driving Global business decisions in all types of business ranging from large corporations to small privately owned companies. Most all professionals come across Microsoft Excel at some point in their careers. Who is this class for? This is a beginner and intermediate level class. Topics covered in class? The class covers the layout of the Excel interface. During this process many of the interface features are shown in action. After the interface components are covered, the next part of the class focuses on a few of the key formulas used by Excel and the final part of the class is an example of the utilization of Excel. Most of the components are covered during the layout overview. The overview shows how each one of these components works independently. The charting feature of excel is studied in detail with 2 chapters dedicated to this feature. The formulas portion of the class covers some of the most widely used Excel formulas. Best way to learn from this class? The best way to learn from this class is by revisiting the lectures and watching the lectures in full screen. Certificate? A certificate for this class can be earned through the completion of all the modules of the class. Certificate is delivered through email. Time Commitment? Students do not need to watch the complete class in a single sitting. Students have the ability to return to lectures and re-visit lectures.

Given how big a part technology plays in both work and life in general, not only must we know the technology of today, we must be able to adapt to the many new technologies quickly. That ability to adapt is a skill all on its own. Though it is intertwined with technological know-how, it is a skill on its own that can be learned with practice. This course will lay out the basics of that skill of technological adaptability while providing exercises that will help the student start building the skill.

This complete collection gives you the most powerful functions in the most used office software suite in the world. 1. MICROSOFT EXCEL - BEGINNER TO ADVANCED 2. MICROSOFT POWERPOINT - BEGINNER TO ADVANCED 3. MICROSOFT WORD - BEGINNER TO ADVANCED 4. MICROSOFT WINDOWS 10 - BEGINNER TO ADVANCED ---------------------------------------------------------- 1. MICROSOFT EXCEL - BEGINNER TO ADVANCED Do you have a large amount of data? Brand New Over-The-Shoulder Video Series On Quickly & Easily Organize & Manage Huge Amounts Of Data Using MS Excel. Are you looking for an easy to use software that can store and retrieve all your financial data in just a few clicks? If the answer is YES , then... ...then this will be the most important letter you will ever read. The Best Software For Managing & Reporting I have good news for you... Heard of MS Excel? Excel is the most popular program for managing and reporting data. This is largely due to its availability. All computers with windows have MS Excel installed in them. It is also available on Mac OS, on different mobile devices. With the latest version of Office, Office 365, Excel has become available online. This means that users have access to the program from a range of devices, from almost any location. MS Excel is used by over 1.2 billion people on the planet and if you don't know how to use it yet, then you're missing out big time. Powerful & Very Reliable Before we go any further, let me give you some insights about MS Excel: 1. Excel is a well known spreadsheet creating and editing software. 2. Excel was released by Microsoft in 1985. The initial contract was exclusive to Apple, it was not until two years later that the PC version was released. 3. In 1991, Microsoft released Excel 3.0 which was the first software to use the modern toolbar. 4. Since the 2003 version, over 1.2 billion users use Excel on a daily basis. 5. Using the functions and formulas on Excel, users can automatically calculate and update the results on their spreadsheets. 6. With basic programing skills, it is possible to use Excel and Visual Basic to create applications that manage tasks, analyze data and add interactive properties on a spreadsheet. 7. The 2007 Excel version introduced the ability to save documents in different formats including XLSX files. 8. Excel can be used together with some of the Microsoft office tools. Why You Need To Get Started Now: Excel helps you get your work done efficiently. Put together amazing charts and diagrams with Excel. Use Excel to stay on top of the trends. Availability and convenience of Excel. Bring and work on data on one platform. Introducing… Manage & Report With Excel Store, Manage & Retrieve Financial Data In Just Clicks! There’s nothing like this video series. Watch as I show you how to get started with Ms Excel. I reveal my best tips for using some unknown tactics that only a few elite few knows. You get to see everything. I explain everything to you. There will be no guesswork. All you need is just a short hour of your time to learn everything and you’d be ready to get started with it instantly. Here’s What You’ll Discover Inside This Excel Video Training: How to get started with MS Excel. Learn how to get use to the interface and configure your settings. Learn how to create your first sheet and what are the options to select when doing it. Learn how to work with MS Excel templates and properties. How to quickly and easily work with text, formula and others. How to format attractive excel sheets that prints awesomely well. How to use the configuration settings and organize your data properly before working. How to convert your data into graphics and how to make good use of it. Learn how to work with multiple sheets at once to speed up your time. Learn the different techniques involved in creating Excel books like the pros do. Useful tips to become more productive when using MS Excel. Learn the some hidden features within this application to speed up your work. Integrating your work with other applications. Work smarter and accomplish more by using these secret advices that only a few know about. ------------------------------------------------------------------------------------------ 2. MICROSOFT POWERPOINT - BEGINNER TO ADVANCED Do you have a business proposal to present to your clients? ...or maybe you are just an infopreneur looking to sell your knowledge online… If your answer is a big yes... then this could be the most important letter you will ever read. Do It Like The Pros Do you know what all the top speakers have in common when they deliver a message to their audience? In one word: Powerpoint. That’s right. They use Powerpoint to present their ideas to the public. Why? Because it’s super easy to use and it’s very flexible. Did You Know… 1. PowerPoint was created by Robert Gaskins and Dennis Austin in 1987, then it was an independent company owned by Forethought, Inc. 2. The software was initially developed to work on Macintosh computers only. Microsoft decided to acquire PowerPoint the very same year it was developed, they paid $14million. 3. In 1993 PowerPoint became part of Microsoft Office. 4. PowerPoint's market share is estimated to be around 95% together with that of Microsoft office. 5. Currently, over 500 million people use PowerPoint, with about 30 million presentations being created everyday. 6. Over 6 million teachers around the world use PowerPoint for classroom lectures. While more than 120 Million people use PowerPoint to create business presentations. 7. PowerPoint is now available as an app across all mobile devices. 8. PowerPoint Online is a cloud-based version of PowerPoint that allows users to create, edit, and share PowerPoint presentations. Users can work with others on shared projects, in real-time. Why You Need To Get Started Now: Stay on top of your presentations with PowerPoint mobile PowerPoint online provides the highest level of convenience Make use of PowerPoint templates in over 40 categories. Keep your thoughts and ideas organized for a presentation Keep the attention and engagement of your audience Introducing… Idea Presentation With Powerpoint How To Organize & Present Your Ideas With Powerpoint There’s nothing like this video series. Watch as I show you how to get started on Powerpoint and how to use it organize your ideas with it. I reveal my best tips for using some unknown tactics that only a few elite few knows. You get to see everything. I explain everything to you. There will be no guesswork. All you need is just a short hour of your time to learn everything and you’d be ready to get started with it instantly. Here’s What You’ll Discover Inside This PowerPoint Video Training: How to get started with Powerpoint. Learn how to get use to the interface and configure your settings. Learn how to create your first presentation slide and what are the options to select when doing it. Learn how to work with Powerpoint templates and backgrounds. How to quickly and easily work with body text and headlines. How to create attractive powerpoint slides that will WOW your audience. How to use the configuration settings and organize your ideas properly in these slides. How to insert graphics in your presentation slides and how to make good use of it. Learn how to clone multiple slides at once to speed up your time. Learn the different techniques involved in creating presentations like the pros do. How to use Powerpoint Animations to impress your audience. How to customize Shapes use Objects in Powerpoint. Learn how to group and ungroup functionalities with your favorite tool. How to create space within Powerpoint shapes and internal margins How to add and use quick access toolbar buttons Learn how to format text, resize and rotate objects easily. How to use the slide structure and how to succeed with it. Learn the different techniques used by top speakers to make their presentation interesting. And many more... ---------------------------------------------------------- 3. MICROSOFT WORD - BEGINNER TO ADVANCED Brand New Over-The-Shoulder Video Series On How To Write Better & Faster Using MS Word. Do you want to write better? Do you need a reliable word processing software that will help you create text documents, print them on paper or even save them as PDF files? If the answer is a big YES... ...then this will be the most important letter you will ever read. The Best On The Planet I have good news for you... Heard of MS Word. No word processor is as convenient as MS Word. From formatting to split view to tracking changes and project sharing, MS Word just makes things easier. You can work on a document and have other people review and contribute to the content. Even better, you can track all changes made to a Word document and even revert to an earlier version. MS Word is the best word processing software on the planet and if you don't know how to use it yet, then you're missing out big time. 90% Market Share Before we go any further, let me give you some insights about MS Word: Microsoft first released Word on October 25 1983. When it was released it was known as Multi-Tool Word for Xenix systems. From its time of release up to 1994, Word was boasting of an impressive 90% share market. Word has different licenses for different stakeholders. Commercial versions of Word are licensed as a standalone product or as a component of Microsoft Office. Word was made available on Mac and PC, besides these two, the only other desktop platform to be graced with its own version of Word was the Atari ST. AutoCorrect was introduced to the sixth version of Word in 1993. Before then, users had to correct their own typing, spelling and grammar mistakes. In 2013, Microsoft introduced the first touch friendly version of Word. Word is available on mobile devices and online for easy accessibility. Word is included in the latest version of Microsoft Office, Office 365. Why You Need To Get Started Now: Word is available everywhere. Create different file formats using Word. Easy to use and integrate with other tools. Identify and resolve grammar and spelling issues with Word. Word is very convenient. Introducing… Write Better With Word Better, Faster, Smarter. There’s nothing like this video series. Watch as I show you how to get started with Ms Word. I reveal my best tips for using some unknown tactics that only a few elite few knows. You get to see everything. I explain everything to you. There will be no guesswork. All you need is just a short hour of your time to learn everything and you’d be ready to get started with it instantly. Here’s What You’ll Discover Inside This Word Video Training: How to get started with MS Word. Learn how to get use to the interface and configure your settings. Learn how to create your first document and which features to select when doing it. Learn how to work with MS Word templates and backgrounds. How to quickly and easily work with text, colors and others. How to format attractive word document that prints awesomely well. How to use the configuration settings and organize your ideas properly before writing. How to insert graphics in your documents and how to make good use of it. Learn how to work with multiple documents at once to speed up your time. Learn the different techniques involved in creating word documents like the pros do. Useful tips to become more productive when using MS Word. Learn the some hidden features within this application to speed up your work. Integrating your work with other applications. Work smarter and accomplish more by using these secret advices that only a few know about. And so many more... -------------------------------------------------- 4. MICROSOFT WINDOWS 10 - BEGINNER TO ADVANCED It's the best OS available... Brand New Over-The-Shoulder Video Series On How To Get Started With Windows 10 In Just Minutes From Now. Used by over 2 billion people daily on the planet... It is recognized to be the gold standard operating system for all PCs. Meet Windows 10. Microsoft’s Flagship Operating System Windows 10 is the latest version of Microsoft's flagship operating system which was released in 2015. Windows is the most used operating system on the planet; this is probably because it is compatible with most devices. Anywhere you go you are assured of coming across a device running on windows and that makes it possible to work on the go and take some of your software with you without difficulties. Windows 10 is installed on every PC and if you do not know how to use it yet, then you're missing out big time. Superior Technology Before we go any further, let me give you some insights about Windows 10: Windows 10 is the latest version of Microsoft's flagship operating system, it was released in 2015. Windows 10 introduces a range of new apps that can run across multiple Microsoft products including mobile devices and the Xbox One. The interface for Windows 10 was changed to adapt to the touch screen-optimized devices running on Windows operating systems. Windows 10 was developed to power all different kind of devices, including mobile and PC. The Windows 10 interface supports different input devices, the normal analogue input and the new digital touch screen technology. Windows 10 brings back the famous start menu, with new added functionalities of course. According to Microsoft, Windows 10 is that last version of Windows to be released. On Windows 10, Microsoft Edge replaces Internet Explorer. Why You Need To Get Started Now: Windows 10 has a free preview. Windows brought back the start menu. Windows 10 introduces the artificial assistant Cortana. Make use of Windows Virtual Desktops. Windows is compatible with most devices and is the most used operating system. Introducing… Get Started With Window 10 The Gold Standard There’s nothing like this video series. Watch as I show you how to get started with Windows 10. I reveal my best tips for using some unknown tactics that only a few elite few knows. You get to see everything. I explain everything to you. There will be no guesswork. All you need is just a short hour of your time to learn everything and you’d be ready to get started with it instantly. Here’s What You’ll Discover Inside This Video Training: How to get started with Windows 10. Learn how to get use to the interface and configure your settings. Learn how to create your user account and which features to select when doing it. Learn how to work with your screen resolutions and backgrounds. How to quickly and easily work with fonts, colors and others. How to install programs and add hardware. How to use the configuration settings and organize it according to your preferences. How to find all the vital hardware information you need. Learn how to work with multiple files at once to speed up your time. Learn how to do a scandisk to check and fix errors. Useful tips to become more productive when using Windows 10. Learn some hidden features within this OS to speed up your work. Integrating your work with other applications. Work smarter and accomplish more by using these secret advice that only a few know about. And so much more...

Wo sind eigentlich die kleinen Tricks und Tipps, die das Office-Leben erleichtern können. In diesem Kurs findest du einige davon. Es gibt immer wieder Funktionen, die man schon x-mal aufgerufen hat, aber trotzdem hat man manchmal ein Häkchen übersehen, aber gerade dieses dieses eröffnet ganz neue Möglichkeiten. In diesem Kurs zeige ich dir einige davon, Dieser Kurs gilt als Ergänzung zu den anderen Office Kursen von mir.

This program aims to simplify the task of human resource personnel who deal with various types of data, ranging from recruitment, compensation, employee benefit, workforce planning and development programs. It is particularly useful in HR workloads where the HR practitioner needs to perform calculation for salary adjustments and bonus. They will be exposed to "what if" analysis when it comes to a collective agreement on negotiation for bonus, salary and increment proposals for management. Impress your management with the right techniques and skills on how to manage HR data efficiently and to perform the right analysis. Basic Microsoft Windows knowledge is essential with the following pre-requisites: Able to switch between task applications Able to “Create", “Save", “Open" and “Print" spreadsheet Able to use “Undo" or “Redo" function Able to print a spreadsheet with headers and footers added Able to create simple formulas (additional, subtraction, multiplication and division) Able to create simple functions (Sum, Average, Count, Max & Min) Upon completion of this program, participants will: Have a better comprehension on how functions work in Excel Be better able to handle text data Maximize the benefits of filters Be more confident in creating Excel reports Know how to use validation to ensure database integrity Be able to make fast decision with the use of the logical function Learn how to extract relevant data with LOOKUP functions Ensure they obtain data consistency with functions Analyzing Data with Statistical and Math Functions Work with Date Functions Know how to explore various possibilities with “What IF analysis"? Merging Data from Multiple Worksheets Know how to analyzing data with pivot table Identify the differences between custom formatting vs. conditional formatting Gain confidence and learn valuable tips

Everyday, for most of the hours of your day, you work on your computer, trying to convert your thoughts and intentions into digital files. And if you are like most people, that means hand on your mouse, clicking on menus, moving a slow digital finger and pointing and clicking . You're building spreadsheets, formatting documents, building presentations. What if you could do you work in half the time, or do twice as much in the same amount of time it takes you today? This course will make you FASTER. You'll go through the major programs of Excel, Word and PowerPoint and learn the shortcut keystrokes that help you do your everyday, every minute activities at the speed you think them, not the speed you can point and click. You'll also learn some super powerful, but rarely discovered speed tips, like selecting visible cells only in a single click, or inserting a custom header format in a single action. Because this is not a course on specific features only useful in specific situations, but rather general tools to use across all situations, you can instantly apply what you learn in this course to the files and programs you are using today. So join the course and let's start getting faster at Microsoft Office today!

Master the Ins and Outs of Microsoft Office and Boost Your Office’s Productivity. Spreadsheets with Excel 2013 Documents with Word 2013 E-mail with Outlook 2013 Presentations with PowerPoint 2013 Databases with Access 2013 Print Publications with Publisher 2013 Make Your Office More Efficient with Microsoft’s Premier Office Management Software Whether you need to create a spreadsheet for data analysis, a database of customer contacts, or a brochure that outlines the strengths and appeal of your organization, Microsoft Office is the choice of many office professionals. Enjoy significant control over your calendar and communication with Outlook or create engaging presentations with PowerPoint. Many people are aware of the basics of what Office can do, but learning the more advanced capabilities of the programs in Office gives you greater flexibility and opportunities for creativity. Microsoft Office is designed to make accomplishing office tasks easier and more efficient. Contents and Overview The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office. Through over 71 hours of video lectures and 8 quizzes, you’ll learn everything you need to know to make your office run more efficiently with Office 2013. Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses. Excel 2013 Advanced: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns. Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work. Outlook 2013: Gain control of your inbox and avoid accumulating hundreds of unanswered emails. PowerPoint 2013: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools. Access 2013 For Beginners and Access 2013 Advanced: Become a master of data management, tracking customer information and buying patterns. Publisher 2013: Create professional looking print publications to communicate the strengths and purpose of your organization. When you complete this course, you’ll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013. ** Updated June 2017. Course transcripts now available.

**This course includes practice exercises and LIFETIME access** Massive value bundle - 3 full courses in one! Learn Excel, PowerPoint and Word 2019 with Microsoft Office experts Simon Sez IT. This mega Microsoft Office bundle is perfect if you're looking to finally get to grips with Excel, PowerPoint and Word. Each course goes into depth on how to get the most from each program and will  help you become an intermediate user. What's included? Excel 2019 What's new in Excel 2019 Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns and cells Cut, Copy and Paste Introduction to functions and formulas Formatting in Excel, including formatting cells and numbers Creating charts and graphs Sorting and Filtering Introduction to PivotTables Logical and lookup formulas - the basics PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word ***Exercise and demo files included*** This bundle includes: 21+ hours of video tutorials 250+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… “I've been familiar with this program for years, but am getting more comfortable and learning more than I could have imagined this early in the course.” - Aimee Hutcherson “I'm learning alot of new material that I had no idea existed. So yes , I'm very much liking this course. Will continue to practice all the new skills I've learned thus far." - Eralda Chung-Colon “I enjoy learning all of the new things in this course so far and I really appreciate how thorough the instructor is at explaining everything. Great Course!!" - Jennifer Lambert Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more!

Why to buy individual courses when this complete package will give you everything you need! Boost your career and stand out from others in crowd!! 1. Microsoft Word (Basic course) 2. Microsoft Word (Advanced course) 2. Microsoft Excel (Basic course) 4. Microsoft Excel (Advanced course) 3. Unlock Macros & VBA Programming course Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course: Looking for an online Excel course to improve your skills and save time but don't know where to start? I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. Microsoft Word complete Package - Don't use just Word, learn tips and tricks with this course to be a smart user. This course includes basic level, intermediate level and advanced level of MS Word. Enroll now to go from beginning to Advanced user. At completion of this course you will have mastered the Microsoft Word. Microsoft Excel: By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. Microsoft Word: At completion of this course you will have mastered the most popular and sought after Microsoft Word tools and come away with confidence to complete many Word tasks with efficiency and grace. Below are just a few of the topics you will master: Creating Dynamic Microsoft Word Documents Effectively Formatting a Document with Styles Prepare Documents for Printing and Exporting Manage Large Documents Working with Page and Section Breaks Control Page Orientation Create and Manage Table Layouts Work with Tab Stops to Align Content Properly Insert Media and Images Perform Mail Merges to create Mailing Labels and Form Letters Manage Templates Protect Documents from Edits Track and Accept/Reject Changes to a Document Build Dynamic Table of Contents and much, much more... What differentiates this course from other Courses? Yes, there are many Microsoft Office Courses out there teaching you the important functions and features you need to master. BUT, do you get step-step-step learning with of Microsoft Word, Microsoft Excel with Quizzes, Exercises and VBA programming all in one course? So, what are you waiting for? Enroll Today and take the next step in mastering Excel, Word and VBA Programming. Boost your career and stand out from others in crowd . Go from Novice to Ninja in all this complete package of Microsoft Word, Microsoft Excel, Macros & VBA! Become a certified Excel, Word & VBA Ninja Today. The course comes with lifetime access. Buy now. Watch anytime.

Das Video-Training für Office 2013 im Beruf, Film für Film zum Erfolg Verschaffen Sie sich den entscheidenden Vorteil im Berufsleben. Diese Trainings sind speziell für Berufstätige konzipiert. Auf Trainings wie  markieren, speichern, löschen und auf ganz einfache Funktionen wurde  verzichtet. Die Konzentration liegt ganz klar auf den Funktionen und Möglichkeiten, die Sie am meisten weiter bringen und die man kennen  muss. Ideal auch für Umsteiger aus anderen Office Versionen. Mit diesen Videotrainings werden Ihnen detailliert die Möglichkeiten  aufgezeigt. Es werden Ihnen die einzelnen Arbeitsschritte am Bildschirm  gezeigt, die Sie dann leicht auf ihre Aufgaben übertragen können. Nach  dem Training werden Sie Ihre Aufgaben schneller und automatisierter  erledigen können. In diesem Training bekommen Sie unsere sechs Trainings für - Access 2013 im Beruf - Excel 2013 im Beruf - Outlook 2013 im Beruf - PowerPoint 2013 im Beruf - Windows 8 Einstieg - Word 2013 im Beruf Sie erlernen alles, was Sie benötigen, um in der Arbeitswelt zu bestehen und Ihre Kollegen zu beeindrucken. Highlights dieses Videotrainings: - Sie lernen das, was Sie weiter bringt - Sie brauchen keine Tests bestehen, um die nächste Trainingseinheit zu beginnen, Sie bestimmen den Ablauf - Keine Installation, Sie können sofort starten - Sie bestimmen Tempo und Uhrzeit - Alles kann anhand von mitgelieferten Dateien selbst ausprobiert werden - Die vielen Praxisbeispiele können Sie direkt selbst nachvollziehen oder auch ganz individuell anpassen.